Driver 8.1 : fails contacting the server with routable address

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enig33B59D5899DBC964322AE0D6
Content-Type: multipart/alternative;
boundary="------------080309090705040107040704"

This is a multi-part message in MIME format.
--------------080309090705040107040704
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,

I'd like to use the postgresql driver in Access, in order to query a
postgresql server in my company. I'm linking tables inside Access with
the driver, and all the setup works fine.
But there is a very strange issue when closing the file and re-opening it=

When I do all this stuff on my client and a test server *all works
great*. My server have the address *192.168.*.**. I don't want Access to
remember the password. When I open the file and click on a table, the
driver window pops up and I have to type it.
When I try to do the same with the production server (with *a routable
address*) I get an issue. The driver pop up does not appear and it seems
to try to contact the server with the good login, but the password can't
be the good one. And then, it sends an error.
Then, I do the exact same thing from another client, but querying my
testing server. The IP address used is then routable (my test server is
a virtual one, using NAT). I query the exact same server from another
location. And I experienced the exact same error.
No problem for linking the tables, but when I close then reopen Access,
it seems to try to directly contact the server without asking me the
password. And then, it fails.

I tried the previous driver version (7.*), all works fine. But I just
can not use it because i need the SSL support (and this version seems
not to support it).

Did you experienced the same issue ? Could you give me more precisions ?
Could you help me ?

Thanks

--=20
Guillaume Gautreau
Responsable projets SI
Bureau P-417
Tel : +33 (0)1.64.15.33.22
Ecole des ponts
6 et 8 avenue Blaise Pascal - Cit=E9 Descartes
Champs-sur-Marne - 77455 Marne la Vall=E9e cedex 2

Ce message a =E9t=E9 sign=E9 num=E9riquement avec GnuPG.


--------------080309090705040107040704
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable






Hi,



I'd like to use the postgresql driver in Access, in order to query a
postgresql server in my company. I'm linking tables inside Access with
the driver, and all the setup works fine.

But there is a very strange issue when closing the file and re-opening
it.

When I do all this stuff on my client and a test server all works
great. My server have the address 192.168.*.*. I don't want
Access to remember the password. When I open the file and click on a
table, the driver window pops up and I have to type it.

When I try to do the same with the production server (with a
routable address) I get an issue. The driver pop up does not appear
and it seems to try to contact the server with the good login, but the
password can't be the good one. And then, it sends an error.

Then, I do the exact same thing from another client, but querying my
testing server. The IP address used is then routable (my test server is
a virtual one, using NAT). I query the exact same server from another
location. And I experienced the exact same error.

No problem for linking the tables, but when I close then reopen Access,
it seems to try to directly contact the server without asking me the
password. And then, it fails.



I tried the previous driver version (7.*), all works fine. But I just
can not use it because i need the SSL support (and this version seems
not to support it).



Did you experienced the same issue ? Could you give me more precisions ?<=
br>
Could you help me ?



Thanks

--=20

Guillaume Gautreau

Responsable projets SI

        Bureau P-417

        Tel : +33 (0)1.64.15.33.22

        Ecole des ponts

        6 et 8 avenue Blaise Pascal - Cité Descartes

        Champs-sur-Marne - 77455 Marne la Vallée cedex 2



Ce message a été signé numériquement avec Gnu=

PG.

Re: Driver 8.1 : fails contacting the server with routableaddress

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enig775DD9146182CBAEC8AAFDDD
Content-Type: multipart/alternative;
boundary="------------020509020605000400050309"

This is a multi-part message in MIME format.
--------------020509020605000400050309
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I have more precisions about this problem.

Looking at the logs, it appears that :

* When contacting a "local" server (192.168.*.*), the driver asks
the user login and pass
* When contacting another server (routable address), the driver
tempt to use the Access UID ("Admin") with a password.



Guillaume Gautreau a =E9crit :
> Hi,
>
> I'd like to use the postgresql driver in Access, in order to query a
> postgresql server in my company. I'm linking tables inside Access with
> the driver, and all the setup works fine.
> But there is a very strange issue when closing the file and re-opening =
it.
> When I do all this stuff on my client and a test server *all works
> great*. My server have the address *192.168.*.**. I don't want Access
> to remember the password. When I open the file and click on a table,
> the driver window pops up and I have to type it.
> When I try to do the same with the production server (with *a routable
> address*) I get an issue. The driver pop up does not appear and it
> seems to try to contact the server with the good login, but the
> password can't be the good one. And then, it sends an error.
> Then, I do the exact same thing from another client, but querying my
> testing server. The IP address used is then routable (my test server
> is a virtual one, using NAT). I query the exact same server from
> another location. And I experienced the exact same error.
> No problem for linking the tables, but when I close then reopen
> Access, it seems to try to directly contact the server without asking
> me the password. And then, it fails.
>
> I tried the previous driver version (7.*), all works fine. But I just
> can not use it because i need the SSL support (and this version seems
> not to support it).
>
> Did you experienced the same issue ? Could you give me more precisions =
?
> Could you help me ?
>
> Thanks
> --=20
> Guillaume Gautreau
> Responsable projets SI
> Bureau P-417
> Tel : +33 (0)1.64.15.33.22
> Ecole des ponts
> 6 et 8 avenue Blaise Pascal - Cit=E9 Descartes
> Champs-sur-Marne - 77455 Marne la Vall=E9e cedex 2
>
> Ce message a =E9t=E9 sign=E9 num=E9riquement avec GnuPG.

--=20
Guillaume Gautreau
Responsable projets SI
Bureau P-417
Tel : +33 (0)1.64.15.33.22
Ecole des ponts
6 et 8 avenue Blaise Pascal - Cit=E9 Descartes
Champs-sur-Marne - 77455 Marne la Vall=E9e cedex 2

Ce message a =E9t=E9 sign=E9 num=E9riquement avec GnuPG.


--------------020509020605000400050309
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable




Type">


I have more precisions about this problem.



Looking at the logs, it appears that :

• When contacting a "local" server (192.168.*.*), the driver asks
  the user login and pass


• When contacting another server (routable address), the driver
  tempt to use the Access UID ("Admin") with a password.

Hi,



I'd like to use the postgresql driver in Access, in order to query a
postgresql server in my company. I'm linking tables inside Access with
the driver, and all the setup works fine.

But there is a very strange issue when closing the file and re-opening
it.

When I do all this stuff on my client and a test server all works
great. My server have the address 192.168.*.*. I don't want
Access to remember the password. When I open the file and click on a
table, the driver window pops up and I have to type it.

When I try to do the same with the production server (with a
routable address) I get an issue. The driver pop up does not appear
and it seems to try to contact the server with the good login, but the
password can't be the good one. And then, it sends an error.

Then, I do the exact same thing from another client, but querying my
testing server. The IP address used is then routable (my test server is
a virtual one, using NAT). I query the exact same server from another
location. And I experienced the exact same error.

No problem for linking the tables, but when I close then reopen Access,
it seems to try to directly contact the server without asking me the
password. And then, it fails.



I tried the previous driver version (7.*), all works fine. But I just
can not use it because i need the SSL support (and this version seems
not to support it).



Did you experienced the same issue ? Could you give me more precisions ?<=
br>
Could you help me ?



Thanks

--=20

Guillaume Gautreau

Responsable projets SI

        Bureau P-417

        Tel : +33 (0)1.64.15.33.22

        Ecole des ponts

        6 et 8 avenue Blaise Pascal - Cité Descartes

        Champs-sur-Marne - 77455 Marne la Vallée cedex 2



Ce message a été signé numériquement avec Gnu=

PG.

--=20

Guillaume Gautreau

Responsable projets SI

        Bureau P-417

        Tel : +33 (0)1.64.15.33.22

        Ecole des ponts

        6 et 8 avenue Blaise Pascal - Cité Descartes

        Champs-sur-Marne - 77455 Marne la Vallée cedex 2



Ce message a été signé numériquement avec Gnu=

PG.

Re: Driver 8.1 : fails contacting the server with routable address

Hello Guillaume,

Monday, January 21, 2008, 2:33:53 PM, you wrote:

GG> * When contacting a "local" server (192.168.*.*), the driver asks
GG> the user login and pass
GG> * When contacting another server (routable address), the driver
GG> tempt to use the Access UID ("Admin") with a password.

Did you check that the pgpass file does not contain the login data for
the remote server? See the manual:


Rainer


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: Driver 8.1 : fails contacting the server with routableaddress

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enigBD784459E70648A644572849
Content-Type: multipart/alternative;
boundary="------------030406040803030903080206"

This is a multi-part message in MIME format.
--------------030406040803030903080206
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi Rainer,

Thanks for your answer.
I checked that file, I found one entry (not in relation with this test).
I deleted it and re-built an Access file in order to make a test.

* It did not work :
o Connexion to the remote server is not done properly. It
tries to use some authentification data that I did not
filled in. Name used : "Admin" (does not correspond to my
real login name).
o Connexion to the test server (in personnal network) worked,
the driver poped up asking my login and password.
* No new entry was added to the file.


Rainer Bauer a =E9crit :
> Hello Guillaume,
>
> Monday, January 21, 2008, 2:33:53 PM, you wrote:
>
> GG> * When contacting a "local" server (192.168.*.*), the driver as=
ks
> GG> the user login and pass
> GG> * When contacting another server (routable address), the driver=

> GG> tempt to use the Access UID ("Admin") with a password.
>
> Did you check that the pgpass file does not contain the login data for
> the remote server? See the manual:
>
>
> Rainer
>
>
> ---------------------------(end of broadcast)--------------------------=
-
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that you=
r
> message can get through to the mailing list cleanly
> =20

--=20
Guillaume Gautreau
Responsable projets SI
Bureau P-417
Tel : +33 (0)1.64.15.33.22
Ecole des ponts
6 et 8 avenue Blaise Pascal - Cit=E9 Descartes
Champs-sur-Marne - 77455 Marne la Vall=E9e cedex 2

Ce message a =E9t=E9 sign=E9 num=E9riquement avec GnuPG.


--------------030406040803030903080206
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable




Type">


Hi Rainer,



Thanks for your answer.

I checked that file, I found one entry (not in relation with this
test). I deleted it and re-built an Access file in order to make a test.<=
br>

• It did not work :




• Connexion to the remote server is not done properly. It tries
  to use some authentification data that I did not filled in. Name used :
  "Admin" (does not correspond to my real login name).
  
  


• Connexion to the test server (in personnal network) worked, the
  driver poped up asking my login and password.




• No new entry was added to the file.

>

Hello Guillaume,



Monday, January 21, 2008, 2:33:53 PM, you wrote:



GG>     * When contacting a "local" server (192.168.*.*), the driver a=

sks

GG>       the user login and pass

GG>     * When contacting another server (routable address), the drive=

r

GG>       tempt to use the Access UID ("Admin") with a password.



Did you check that the pgpass file does not contain the login data for

the remote server? See the manual:


/8.2/static/libpq-pgpass.html"><http://www.postgresql.org/docs/8.2/sta=

tic/libpq-pgpass.html>



Rainer





---------------------------(end of broadcast)---------------------------

TIP 1: if posting/reading through Usenet, please send an appropriate

       subscribe-nomail command to 
 href=3D"mailto:majordomo@postgresql.org">majordomo@postgresq l.org so =

that your

       message can get through to the mailing list cleanly

  

--=20

Guillaume Gautreau

Responsable projets SI

        Bureau P-417

        Tel : +33 (0)1.64.15.33.22

        Ecole des ponts

        6 et 8 avenue Blaise Pascal - Cité Descartes

        Champs-sur-Marne - 77455 Marne la Vallée cedex 2



Ce message a été signé numériquement avec Gnu=

PG.